set hive.exec.dynamic.partition=true;            --  动态分区
set hive.exec.dynamic.partition.mode=nonstrict;
set hive.exec.max.dynamic.partitions=100;         --  每天生成 60 个分区
set hive.exec.max.dynamic.partitions.pernode=100; --  每天生成 60 个分区
insert overwrite table jms_dwd.dwd_yl_sys_package_diff_snapshot_dt partition(dt)
select
package_different_id
,express_org_code
,express_org_name
,sender_province_id
,sender_province_name
,sender_city_id
,sender_city_name
,sender_district_id
,sender_district_name
,sender_town_id
,sender_town_name
,consolidation_id
,consolidation_code
,consolidation_name
,express_center_code
,express_center_short_code
,create_by
,update_by
,create_by_name
,update_by_name
,create_time
,update_time
,operator
,express_center_name
,type
,express_agent_code
,express_agent_name
,name
,version
,snapshot_time
,dt
from jms_ods.yl_sys_package_diff_snapshot
where dt= '{{ execution_date | cst_ds }}'
distribute by 1 ;